//
//  CrudeOilCode.h
//  DataCollector
//
//  Created by jiro on 12/06/11.
//  Copyright 2012 jiro music. All rights reserved.
//

#import <Cocoa/Cocoa.h>

#import "../BaseClasses.h"

class CrudeOilCodeType
{
public:

	enum Type
	{
		Murban39,
		SaharanBlend44,
		Cabinda32,
		Fateh32,
		Oriente30,
		Heavy30,
		Light34,
		Kirkuk36,
		Kuwait31,
		EsSider37,
		Khafji28,
		BonnyLight37,
		Forcados31,
		Dukhan40,
		ArabianHeavy27,
		ArabianLight34,
		ArabianMedium31,
		Bachaquero17,
		Bachaquero24,
		TiaJuanaLight31,
		Gippsland42,
		SeriaLight37,
		Kole34,
		CanadianPar40,
		HeavyHardisty22,
		Lloydblend22,
		Daqing33,
		CanoLimon30,
		SuezBlend33,
		Mandji30,
		Minas34,
		TapisBlend44,
		Isthmus33,
		Maya22,
		EkofiskBlend42,
		OmanBlend34,
		Urals32,
		BrentBlend38,
		NoName,
	};
};

@interface CrudeOilCode : DbCodeTableEntry
{
	NSString* productCountryCode;

}

@property ( assign ) NSString* productCountryCode;

+ (id) crudeOilCodeWithValues: (NSArray*) values;

+ (NSString*) queryInsertInitialValues;

//	---- sql query  ---- //
+ (NSString*) querySelectAll;

- (NSString*) queryInsert;
- (NSString*) queryInsertValue;

@end
